Атом - техцентр авто

MySQL статистика (23)

Query	Rows	Time	Cached
SELECT items.id, items.parent_id, items.title, items.is_hidden_in_menu, items.sort_order, items.href, menus.code as menu_code, menus.use_code_in_links as menu_code_in_links, blocks.id as block_id, blocks.code as block_code, blocks.description, blocks.content, blocks.template, blocks.block_type, f.id as image_id, f.disk_name as image_path FROM admin_menu_items as items LEFT JOIN admin_menus as menus ON menus.id = items.menu_id LEFT JOIN admin_text_blocks as blocks ON blocks.id = items.text_block_id LEFT JOIN db_files as f ON f.master_object_id = items.id AND f.master_object_class = 'Admin_MenuItem' AND f.field = 'image' WHERE items.is_hidden is null ORDER BY items.parent_id, items.sort_order	34	0.002203	false
select count(*) from ( (select id as object_id, 'News_Post' as object_name, publish_date as sdate from news_posts where (title like '%ремонт%') OR (description like '%ремонт%') OR (content like '%ремонт%') OR (title like '%редуктора%') OR (description like '%редуктора%') OR (content like '%редуктора%') order by publish_date desc) UNION (select id as object_id, 'Admin_TextBlock' as object_name, updated_at as sdate from admin_text_blocks where (admin_text_blocks.code like '/%') AND ((title like '%ремонт%') OR (content like '%ремонт%') OR (description like '%ремонт%') OR (title like '%редуктора%') OR (content like '%редуктора%') OR (description like '%редуктора%'))) ) as hell_s_partition	1	0.001066	false
(select id as object_id, 'News_Post' as object_name, publish_date as sdate from news_posts where (title like '%ремонт%') OR (description like '%ремонт%') OR (content like '%ремонт%') OR (title like '%редуктора%') OR (description like '%редуктора%') OR (content like '%редуктора%') order by publish_date desc) UNION (select id as object_id, 'Admin_TextBlock' as object_name, updated_at as sdate from admin_text_blocks where (admin_text_blocks.code like '/%') AND ((title like '%ремонт%') OR (content like '%ремонт%') OR (description like '%ремонт%') OR (title like '%редуктора%') OR (content like '%редуктора%') OR (description like '%редуктора%'))) order by sdate desc limit 0, 20	7	0.000613	false
SELECT seo_settings.* FROM seo_settings ORDER BY id desc LIMIT 0, 1	1	0.000358	false
update seo_settings set individual_seo_settings = 'a:0:{}'	-	0.000129	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.id = '23') LIMIT 0, 1	1	0.000338	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.id = '26') LIMIT 0, 1	1	0.000358	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.id = '33') LIMIT 0, 1	1	0.000265	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.id = '25') LIMIT 0, 1	1	0.000237	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.id = '20') LIMIT 0, 1	1	0.000217	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.id = '22') LIMIT 0, 1	1	0.000203	false
SELECT (menu_link_calculated_join.title) as menu_link_calculated, admin_text_blocks.* FROM admin_text_blocks LEFT JOIN admin_menu_items as menu_link_calculated_join ON menu_link_calculated_join.text_block_id = admin_text_blocks.id WHERE (admin_text_blocks.id = '21') LIMIT 0, 1	1	0.000205	false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='icon')) as icon_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.text_block_id = '23') LIMIT 0, 1	1	0.000550	false
SELECT admin_menu_items.* FROM admin_menu_items ORDER BY sort_order	34	0.000336	false
SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.id = '4') LIMIT 0, 1	1	0.000149	false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='icon')) as icon_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.text_block_id = '26') LIMIT 0, 1	1	0.000377	false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='icon')) as icon_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.text_block_id = '33') LIMIT 0, 1	1	0.000365	false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='icon')) as icon_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.text_block_id = '25') LIMIT 0, 1	1	0.000348	false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='icon')) as icon_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.text_block_id = '20') LIMIT 0, 1	1	0.000337	false
SELECT admin_menus.* FROM admin_menus WHERE (admin_menus.id = '1') LIMIT 0, 1	1	0.000146	false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='icon')) as icon_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.text_block_id = '22') LIMIT 0, 1	1	0.000393	false
SELECT (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='icon')) as icon_calculated, (select group_concat(db_files.id ORDER BY 1 SEPARATOR ', ') from db_files where db_files.master_object_id = admin_menu_items.id and (master_object_class='Admin_MenuItem' and field='photos')) as photos_calculated, admin_menu_items.* FROM admin_menu_items WHERE (admin_menu_items.text_block_id = '21') LIMIT 0, 1	1	0.000323	false
SELECT admin_module_settings.* FROM admin_module_settings WHERE (admin_module_settings.module_id='admin') AND (admin_module_settings.form_id='default') LIMIT 0, 1	1	0.000482	false

Оставить заявку